﻿CREATE TABLE [dbo].[Offices] (
    [OfficeID]      INT            IDENTITY (1, 1) NOT NULL,
    [OfficeName]    NVARCHAR (255) NULL,
    [Address1]      NVARCHAR (255) NULL,
    [Address2]      NVARCHAR (255) NULL,
    [City]          NVARCHAR (50)  NULL,
    [State]         NVARCHAR (8)   NULL,
    [Zip]           NVARCHAR (50)  NULL,
    [MainTelephone] NVARCHAR (50)  NULL,
    [Fax]           NVARCHAR (50)  NULL,
    [Latitude]      FLOAT          NULL,
    [Longitude]     FLOAT          NULL
);